<?
	include('chksession.php');
		include('conn.php');
	session_start();
   
       $orderid =$_REQUEST['orderid'];
	   $orderdate= $_REQUEST['orderdate'];
       $refnumber= $_REQUEST['refnumber'];
	   $customername= $_REQUEST['customername'];
	   $contactnumber= $_REQUEST['contactnumber'];
	   $deliverydate= $_REQUEST['deliverydate'];
	   $soldby= $_REQUEST['soldby'];
	   $deliveredby= $_REQUEST['deliveredby'];
	   $glassfrom= $_REQUEST['glassfrom'];
	   $note= $_REQUEST['note'];
	   $remarks = $_REQUEST['remarks'];
	   $grandtotal = $_REQUEST['grandtotal'];
	   $advreceived = $_REQUEST['advreceived'];
	   $enteredby = $_REQUEST['enteredby'];
	   
	 
	  
		$sql="update ordertranmast set 
				orderdate='".$orderdate."',refnumber='".$refnumber."',customername='".strtoupper($customername)."',contactnumber='".$contactnumber."',
				deliverydate='".$deliverydate."',soldby='".$soldby."',
				deliveredby='".$deliveredby."',glassfrom='".$glassfrom."',note='".$note."',
				remarks='".$remarks."',grandtotal=".$grandtotal.",advreceived=".$advreceived.", enteredby='".strtoupper($enteredby)."',entrydt=sysdate()	where status=0 and orderid=".$orderid;
		
		 echo $sql;
		 //return;
		$res=mysql_query($sql);
		if($res)
		$msg='Record updated successfully...';					

?>